{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,39,13],[0,2,1,13],[4,1,5,1],[4,2,5,2],[6,0,8,0],[3,2,3,5],[3,9,3,13],[33,0,35,0],[33,5,35,5],[30,0,32,0],[30,5,32,5],[24,0,26,0],[24,5,26,5],[4,3,4,4],[5,3,5,4],[6,5,8,5],[27,0,29,0],[27,5,29,5],[21,0,23,0],[21,5,23,5],[18,0,20,0],[18,5,20,5],[4,0,5,0],[15,0,17,0],[15,5,17,5],[12,0,14,0],[12,5,14,5],[9,0,11,0],[9,5,11,5]]}
[null,null,"The cost of growing crops\n\nThis tool can be used to understand basic costs of growing different types of crops. \n It is recommended to calculate your own cost of production in order to make informed decisions for your businesses  - averages without context doesn’t tell the full story …. Every farm is different.\n\nEdit yield figures, costs and prices to complete different scenario planning. "]
[]
[]
[null,null,"Data abstracted from John Nix 47th Edition\nEdit these figures to suit your farm costs\nCalculate your accurate costs through www.farmbench.ahdb.org.uk ",{"$nulls":6},"Data abstracted from John Nix 47th Edition\nEdit these figures to suit your farm costs\nCalculate your accurate costs through www.farmbench.ahdb.org.uk "]
["Crop",null,"Yield t/ha","Average Cost of Production ",null,"Price per tonne ","Total income ","Profit",null,"Labour Cost Removed (regular labour unpaid)",null,"Rent Cost Removed",null,"Add Single Farm Payment??"]
[null,null,null,"£/Ha",null,"2019-03-01","£/Ha","£/Ha",null,225,null,100,null,100]
["Winter Feed Wheat","Lowest",7.25,"Variable",663,130,{"$f":"C7*F7","v":942.5},{"$f":"G7-E9","v":-640.5},null,{"$f":"H7+J6","v":-415.5},null,{"$f":"J7+L6","v":-315.5},null,{"$f":"L7+N6","v":-215.5}]
[null,"Average",8.5,"Fixed",920,null,{"$f":"C8*F7","v":1105},{"$f":"G8-E9","v":-478},null,{"$f":"H8+J6","v":-253},null,{"$f":"J8+L6","v":-153},null,{"$f":"L8+N6","v":-53}]
[null,"Highest",9.75,"Total",{"$f":"E7+E8","v":1583},null,{"$f":"C9*F7","v":1267.5},{"$f":"G9-E9","v":-315.5},null,{"$f":"H9+J6","v":-90.5},null,{"$f":"J9+L6","v":9.5},null,{"$f":"L9+N6","v":109.5}]
["Winter Milling Wheat","Lowest",6.75,"Variable",479,146,{"$f":"C10*F10","v":985.5},{"$f":"G10-E12","v":-413.5},null,{"$f":"H10+J6","v":-188.5},null,{"$f":"J10+L6","v":-88.5},null,{"$f":"L10+N6","v":11.5}]
[null,"Average",7.8,"Fixed",920,null,{"$f":"C11*F10","v":1138.8},{"$f":"G11-E12","v":-260.20000000000005},null,{"$f":"H11+J6","v":-35.200000000000045},null,{"$f":"J11+L6","v":64.799999999999955},null,{"$f":"L11+N6","v":164.79999999999995}]
[null,"Highest",9,"Total",{"$f":"E10+E11","v":1399},null,{"$f":"C12*F10","v":1314},{"$f":"G12-E12","v":-85},null,{"$f":"H12+J6","v":140},null,{"$f":"J12+L6","v":240},null,{"$f":"L12+N6","v":340}]
["Spring Wheat (Mostly Milling)","Lowest",4.75,"Variable",322,145,{"$f":"C13*F13","v":688.75},{"$f":"G13-E15","v":-553.25},null,{"$f":"H13+J6","v":-328.25},null,{"$f":"J13+L6","v":-228.25},null,{"$f":"L13+N6","v":-128.25}]
[null,"Average",5.75,"Fixed",920,null,{"$f":"C14*F13","v":833.75},{"$f":"G14-E15","v":-408.25},null,{"$f":"H14+J6","v":-183.25},null,{"$f":"J14+L6","v":-83.25},null,{"$f":"L14+N6","v":16.75}]
[null,"Highest",4.75,"Total",{"$f":"E13+E14","v":1242},null,{"$f":"C15*F13","v":688.75},{"$f":"G15-E15","v":-553.25},null,{"$f":"H15+J6","v":-328.25},null,{"$f":"J15+L6","v":-228.25},null,{"$f":"L15+N6","v":-128.25}]
["Winter Feed Barley","Lowest",5.5,"Variable",351,120,{"$f":"C16*F16","v":660},{"$f":"G16-E18","v":-611},null,{"$f":"H16+J6","v":-386},null,{"$f":"J16+L6","v":-286},null,{"$f":"L16+N6","v":-186}]
[null,"Average",6.9,"Fixed",920,null,{"$f":"C17*F16","v":828},{"$f":"G17-E18","v":-443},null,{"$f":"H17+J6","v":-218},null,{"$f":"J17+L6","v":-118},null,{"$f":"L17+N6","v":-18}]
[null,"Highest",7.9,"Total",{"$f":"E16+E17","v":1271},null,{"$f":"C18*F16","v":948},{"$f":"G18-E18","v":-323},null,{"$f":"H18+J6","v":-98},null,{"$f":"J18+L6","v":2},null,{"$f":"L18+N6","v":102}]
["Winter Malting Barley","Lowest",5,"Variable",328,136,{"$f":"C19*F19","v":680},{"$f":"G19-E21","v":-568},null,{"$f":"H19+J6","v":-343},null,{"$f":"J19+L6","v":-243},null,{"$f":"L19+N6","v":-143}]
[null,"Average",6,"Fixed",920,null,{"$f":"C20*F19","v":816},{"$f":"G20-E21","v":-432},null,{"$f":"H20+J6","v":-207},null,{"$f":"J20+L6","v":-107},null,{"$f":"L20+N6","v":-7}]
[null,"Highest",7,"Total",{"$f":"E19+E20","v":1248},null,{"$f":"C21*F19","v":952},{"$f":"G21-E21","v":-296},null,{"$f":"H21+J6","v":-71},null,{"$f":"J21+L6","v":29},null,{"$f":"L21+N6","v":129}]
["Spring Malting Barley","Lowest",4.5999999999999996,"Variable",273,146,{"$f":"C22*F22","v":671.59999999999991},{"$f":"G22-E24","v":-521.40000000000009},null,{"$f":"H22+J6","v":-296.40000000000009},null,{"$f":"J22+L6","v":-196.40000000000009},null,{"$f":"L22+N6","v":-96.400000000000091}]
[null,"Average",5.45,"Fixed",920,null,{"$f":"C23*F22","v":795.7},{"$f":"G23-E24","v":-397.29999999999995},null,{"$f":"H23+J6","v":-172.29999999999995},null,{"$f":"J23+L6","v":-72.299999999999955},null,{"$f":"L23+N6","v":27.700000000000045}]
[null,"Highest",6.3,"Total",{"$f":"E22+E23","v":1193},null,{"$f":"C24*F22","v":919.8},{"$f":"G24-E24","v":-273.20000000000005},null,{"$f":"H24+J6","v":-48.200000000000045},null,{"$f":"J24+L6","v":51.799999999999955},null,{"$f":"L24+N6","v":151.79999999999995}]
["Winter Oats","Lowest",5.25,"Variable",267,120,{"$f":"C25*F25","v":630},{"$f":"G25-E27","v":-557},null,{"$f":"H25+J6","v":-332},null,{"$f":"J25+L6","v":-232},null,{"$f":"L25+N6","v":-132}]
[null,"Average",6.3,"Fixed",920,null,{"$f":"C26*F25","v":756},{"$f":"G26-E27","v":-431},null,{"$f":"H26+J6","v":-206},null,{"$f":"J26+L6","v":-106},null,{"$f":"L26+N6","v":-6}]
[null,"Highest",7.65,"Total",{"$f":"E25+E26","v":1187},null,{"$f":"C27*F25","v":918},{"$f":"G27-E27","v":-269},null,{"$f":"H27+J6","v":-44},null,{"$f":"J27+L6","v":56},null,{"$f":"L27+N6","v":156}]
["Spring Oats","Lowest",4.5,"Variable",217,120,{"$f":"C28*F28","v":540},{"$f":"G28-E30","v":-597},null,{"$f":"H28+J9","v":-687.5},null,{"$f":"J28+L9","v":-678},null,{"$f":"L28+N6","v":-578}]
[null,"Average",5.5,"Fixed",920,null,{"$f":"C29*F28","v":660},{"$f":"G29-E30","v":-477},null,{"$f":"H29+J9","v":-567.5},null,{"$f":"J29+L9","v":-558},null,{"$f":"L29+N6","v":-458}]
[null,"Highest",6.5,"Total",{"$f":"E28+E29","v":1137},null,{"$f":"C30*F28","v":780},{"$f":"G30-E30","v":-357},null,{"$f":"H30+J9","v":-447.5},null,{"$f":"J30+L9","v":-438},null,{"$f":"L30+N6","v":-338}]
["Winter Oilseed Rape","Lowest",2.4,"Variable",408,300,{"$f":"C31*F31","v":720},{"$f":"G31-E33","v":-608},null,{"$f":"H31+J6","v":-383},null,{"$f":"J31+L6","v":-283},null,{"$f":"L31+N6","v":-183}]
[null,"Average",3.4,"Fixed",920,null,{"$f":"C32*F31","v":1020},{"$f":"G32-E33","v":-308},null,{"$f":"H32+J6","v":-83},null,{"$f":"J32+L6","v":17},null,{"$f":"L32+N6","v":117}]
[null,"Highest",4.4000000000000004,"Total",{"$f":"E31+E32","v":1328},null,{"$f":"C33*F31","v":1320},{"$f":"G33-E33","v":-8},null,{"$f":"H33+J6","v":217},null,{"$f":"J33+L6","v":317},null,{"$f":"L33+N6","v":417}]
["Spring Oilseed Rape","Lowest",1.5,"Variable",257,300,{"$f":"C34*F34","v":450},{"$f":"G34-E36","v":-727},null,{"$f":"H34+J9","v":-817.5},null,{"$f":"J34+L9","v":-808},null,{"$f":"L34+N6","v":-708}]
[null,"Average",2,"Fixed",920,null,{"$f":"C35*F34","v":600},{"$f":"G35-E36","v":-577},null,{"$f":"H35+J9","v":-667.5},null,{"$f":"J35+L9","v":-658},null,{"$f":"L35+N6","v":-558}]
[null,"Highest",2.75,"Total",{"$f":"E34+E35","v":1177},null,{"$f":"C36*F34","v":825},{"$f":"G36-E36","v":-352},null,{"$f":"H36+J9","v":-442.5},null,{"$f":"J36+L9","v":-433},null,{"$f":"L36+N6","v":-333}]
[]
["For more information and guidance on how to calculate your costs of production, go to: www.farmbench.ahdb.org.uk \nTo assist with understanding the potential price that can be obtained for your crop, go to: https://ahdb.org.uk/markets-and-prices "]